USE DB_TCC
IF EXISTS(SELECT 1 FROM SYSOBJECTS WHERE NAME LIKE 'P_CLIENTE_CONSULTAR')
	DROP PROCEDURE P_CLIENTE_CONSULTAR
GO
CREATE PROCEDURE P_CLIENTE_CONSULTAR(
	@IDCLIENTE VARCHAR(100))
AS BEGIN
	SELECT
		CLI_IDCLIENTE,
		CLI_NMCLIENTE,
		CLI_DESCCLIENTE,
		CLI_ICATIVO,
		CLI_NMUSUARIOINCLUSAO,
		CLI_DTHRINCLUSAO,
		CLI_NMUSUARIOALTERACAO,
		CLI_DTHRALTERACAO
	FROM
		CLIENTE
	WHERE
		CLI_IDCLIENTE = @IDCLIENTE
END